Skip Headers

Oracle® Database Data Warehousing Guide 10g Release 2 (10.2) Part Number B14223-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# What's New in Oracle Database?

This section describes the new features of Oracle Database 10g Release 2 (10.2) and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.

The following section describes new features in Oracle Database:

- Oracle Database 10g Release 2 (10.2) New Features in Data Warehousing

- Oracle Database 10g Release 1 (10.1) New Features in Data Warehousing

## Oracle Database 10g Release 2 (10.2) New Features in Data Warehousing

- SQL Model Calculations

  The `MODEL` clause enables you to specify complex formulas while avoiding multiple joins and `UNION` clauses. This clause supports OLAP queries such as share of ancestor and prior period comparisons, as well as calculations typically done in large spreadsheets. The `MODEL` clause provides building blocks for budgeting, forecasting, and statistical applications.

  See Also: Chapter 22, "SQL for Modeling"

- Materialized View Refresh Enhancements

  Materialized view fast refresh involving multiple tables, whether partitioned or non-partitioned, no longer requires that a materialized view log be present.

  See Also: Chapter 15, "Maintaining the Data Warehouse"

- Query Rewrite Enhancements

  Query rewrite performance has been improved because query rewrite is now able to use multiple materialized views to rewrite a query.

  See Also: Chapter 17, "Basic Query Rewrite"

- Partitioning Enhancements

  You can now use partitioning with index-organized tables. Also, materialized views in OLAP are able to use partitioning. You can now use hash-partitioned global indexes.

  See Also: Chapter 5, "Partitioning in Data Warehouses"

- Change Data Capture

  Oracle now supports asynchronous change data capture as well as synchronous change data capture.

  See Also: Chapter 16, "Change Data Capture"

- ETL Enhancements

  Oracle's extraction, transformation, and loading capabilities have been improved with several `MERGE` improvements and better external table capabilities.

  See Also: Chapter 11, "Overview of Extraction, Transformation, and Loading"

## Oracle Database 10g Release 1 (10.1) New Features in Data Warehousing

- SQL Model Calculations

  The `MODEL` clause enables you to specify complex formulas while avoiding multiple joins and `UNION` clauses. This clause supports OLAP queries such as share of ancestor and prior period comparisons, as well as calculations typically done in large spreadsheets. The `MODEL` clause provides building blocks for budgeting, forecasting, and statistical applications.

  See Also: Chapter 22, "SQL for Modeling"

- Materialized View Refresh Enhancements

  Materialized view refresh has new optimizations for data warehousing and OLAP environments. The enhancements include more efficient calculation and update techniques, support for nested refresh, along with improved cost analysis.

  See Also: Chapter 15, "Maintaining the Data Warehouse"

- Query Rewrite Enhancements

  Query rewrite performance and capabilities have been improved.

  See Also: Chapter 17, "Basic Query Rewrite"

- Partitioning Enhancements

  You can now use partitioning with index-organized tables. Also, materialized views in OLAP are able to use partitioning. You can now use hash-partitioned global indexes.

  See Also: Chapter 5, "Partitioning in Data Warehouses"

- Change Data Capture

  Oracle now supports asynchronous change data capture as well as synchronous change data capture.

  See Also: Chapter 16, "Change Data Capture"

- ETL Enhancements

  Oracle's extraction, transformation, and loading capabilities have been improved with several `MERGE` improvements and better external table capabilities.

  See Also: Chapter 11, "Overview of Extraction, Transformation, and Loading"

- Storage Management

  Oracle's Managed Files has simplified the administration of a database by providing functionality to automatically create and manage files, so the database administrator no longer needs to manage each database file.

  Automatic Storage Management provides additional functionality for managing not only files, but also the disks. In addition, you can now use ultralarge data files.

  See Also: Chapter 4, "Hardware and I/O Considerations in Data Warehouses"